|
|
|
|
|
|
|
|
SpreadsheetRestorePositionAndSelection (Function) In french: TableurRestaurePositionEtSélection Restores: - the scrollbar position in a Spreadsheet control,
- the current worksheet,
- the elements selected in the current worksheet of Spreadsheet control.
These elements have been saved by SpreadsheetSavePositionAndSelection. let MySave = SpreadsheetRestorePositionAndSelection(PSHEET_Spreadsheet1)
// Displays the B1 cell in bold
SpreadsheetSelectPlus(PSHEET_Spreadsheet, "B1")
SpreadsheetStyleSelection(PSHEET_Spreadsheet, psheetBold, True)
// Restores the position/selection
SpreadsheetRestorePositionAndSelection(PSHEET_Spreadsheet1, MySave)
Syntax
SpreadsheetRestorePositionAndSelection(<Spreadsheet control> [, <Save>])
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Save>: Optional character string Save characteristics returned by SpreadsheetSavePositionAndSelection. - If this parameter is not specified, the last backup performed by SpreadsheetSavePositionAndSelection on the control is used (if it exists).
- An error occurs if no backup was performed or if the specified string is invalid.
Remarks Special cases - The name of the control used for the save (SpreadsheetSavePositionAndSelection) can differ from the name used for the restore operation. This feature can be useful to duplicate the position and the selection on two Spreadsheet controls displayed alternatively for example.
- SpreadsheetRestorePositionAndSelection has no effect if the control is empty.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|